/*
 Navicat Premium Data Transfer

 Source Server         : 47.95.234.122
 Source Server Type    : MySQL
 Source Server Version : 50637
 Source Host           : 47.95.234.122:3306
 Source Schema         : linkphp

 Target Server Type    : MySQL
 Target Server Version : 50637
 File Encoding         : 65001

 Date: 18/04/2018 23:19:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lp_blog
-- ----------------------------
DROP TABLE IF EXISTS `lp_blog`;
CREATE TABLE `lp_blog` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(80) NOT NULL,
  `content` text NOT NULL,
  `post_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  `u_id` int(255) unsigned NOT NULL,
  `type` int(255) unsigned NOT NULL DEFAULT '0',
  `is_on` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `pic_url` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_blog
-- ----------------------------
BEGIN;
INSERT INTO `lp_blog` VALUES (1, 'php7 mysqli扩展安装(mysqli_fetch_all函数需要mysqlnd驱动)', 'php7 mysqli扩展安装(mysqli_fetch_all函数需要mysqlnd驱动)，所以编译mysql时必须开启 --enable-mysqlnd --with-mysql=mysqlnd --width-mysqli=mysqlnd --with-pdo-mysql=mysqlnd', '2017-09-24 00:00:00', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (2, '阿里云短信接口调用sdk使用方法', '阿里云短信接口调用sdk使用方法：composer 安装 alisms:composer install liugene/alisms', '2017-09-25 00:00:00', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (3, '测试数据', '测试数据', '2017-09-25 00:00:00', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (4, 'linux系统使用 securecrt进行上传下载文件', '>上传文件：rz：运行该命令会弹出一个文件选择窗口，从本地选择文件上传到服务器(receive) \n\n>下载文件：sz：将选定的文件发送（send）到本地机器', '2017-10-09 09:13:31', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (5, '测试', '测试', '2017-10-09 09:51:55', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (6, 'linux centos7.3 安装Nginx', 'wget http://nginx.org/download/nginx-1.8.1.tar.gz  回车下载\n\ntar -zxvf nginx-1.8.1.tar.gz 解压\n\n解压成功生成目录   nginx-1.8.1\n\ncd nginx-1.8.1 进入该目录\n\n./configure 回车 默认安装在 /usr/local/nginx/下\n\nmake\n\nmake install', '2017-10-09 09:52:53', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (7, 'linux centos7.3 安装pcre阶段', '\n打开 https://sourceforge.net/projects/pcre/files/pcre/8.40 下载 .tar.gz后缀的\n\n通过 rz 回车上传到服务器上进行解压\n\ncd pcre-8.40\n\n配置 ./configure 回车\n\n\n编译\n\nmake 回车\n\nmake install ', '2017-10-09 09:53:44', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (8, 'linux centos7.3 安装PHP', 'cd /usr/local/  进入该目录\n\nwget http://cn2.php.net/distributions/php-5.6.8.tar.gz 下载PHP\n\ntar -zxvf php-5.5.12.tar.gz  解压php\n\n一:安装依赖包\n\nyum install cmake make gcc gcc-c++ libjpeg libjpeg-devel libpng \nlibpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc \nglibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl \ncurl-devel e2fsprogs e2fsprogs-devel krb5-devel libidn libidn-devel openssl expat expat-devel \nopenssl-devel nss_ldap openldap openldap-devel openldap-clients openldap-servers unixODBC-devel \nlibxslt-devel libevent-devel libtool-ltdl bison libtool pcre-devel zip unzip gmp-devel gd gd-devel\n\ncd php-5.5.12 进入该目录\n\n编译和安装php\n\n#./configure --prefix=/usr/local/php  --enable-fpm --with-mcrypt --enable-mbstring --disable-pdo --with-curl --disable-debug  --disable-rpath --enable-inline-optimization --with-bz2  --with-zlib --enable-sockets --enable-sysvsem --enable-sysvshm --enable-pcntl --enable-mbregex --with-mhash --enable-zip --with-pcre-regex --with-mysql --with-mysqli --with-gd --with-jpeg-dir\n\n#make\n\n#make test\n\n#make install\n\n在安装php的过程中，有如下报错：configure: error: xml2-config not found. Please check your libxml2 installation.\n\n解决方法：\n\n重新安装libxml2和libxml2-devel包\n\nyum install libxml2\n\nyum install libxml2-devel -y\n\n重新执行上面的步骤\n\n记住一点 看出错内容：一般出错都是没有安装相应库，安装好在重新执行上面步骤就可以', '2017-10-09 09:54:14', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
INSERT INTO `lp_blog` VALUES (9, 'php内核学习以及扩展开发书籍推荐', 'http://www.cunmou.com/phpbook', '2017-11-17 05:26:02', NULL, 1, 0, 0, '/resource/static/main/img/mysql.png');
COMMIT;

-- ----------------------------
-- Table structure for lp_class
-- ----------------------------
DROP TABLE IF EXISTS `lp_class`;
CREATE TABLE `lp_class` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `p_id` int(255) unsigned NOT NULL DEFAULT '0',
  `classname` varchar(20) NOT NULL,
  `post_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_class
-- ----------------------------
BEGIN;
INSERT INTO `lp_class` VALUES (1, 0, '开发语言', NULL, NULL);
INSERT INTO `lp_class` VALUES (2, 1, 'php', NULL, NULL);
INSERT INTO `lp_class` VALUES (3, 1, 'javascript', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for lp_content
-- ----------------------------
DROP TABLE IF EXISTS `lp_content`;
CREATE TABLE `lp_content` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `content` text,
  `f_id` int(11) NOT NULL,
  `u_id` int(11) NOT NULL,
  `post_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_content
-- ----------------------------
BEGIN;
INSERT INTO `lp_content` VALUES (1, '111', 2, 2, '2017-09-23 08:55:30');
INSERT INTO `lp_content` VALUES (2, './configure --prefix=/usr/local/install/php --enable-fpm --enable-mysqlnd --with-pdo-mysql=mysqlnd --with-mysqli --disable-fileinfo', 3, 2, '2017-09-23 13:45:26');
COMMIT;

-- ----------------------------
-- Table structure for lp_forum
-- ----------------------------
DROP TABLE IF EXISTS `lp_forum`;
CREATE TABLE `lp_forum` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(80) NOT NULL,
  `c_id` int(255) unsigned NOT NULL,
  `u_id` int(255) NOT NULL,
  `post_time` datetime NOT NULL,
  `up_time` datetime DEFAULT NULL,
  `is_on` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_solve` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_forum
-- ----------------------------
BEGIN;
INSERT INTO `lp_forum` VALUES (2, '111', 1, 2, '2017-09-23 00:00:00', NULL, 0, 0);
INSERT INTO `lp_forum` VALUES (3, 'php7 mysqli扩展安装', 1, 2, '2017-09-23 13:45:26', NULL, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for lp_links
-- ----------------------------
DROP TABLE IF EXISTS `lp_links`;
CREATE TABLE `lp_links` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `desc` varchar(50) DEFAULT NULL,
  `role` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `post_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_links
-- ----------------------------
BEGIN;
INSERT INTO `lp_links` VALUES (1, 'linkphp框架', 'mvc框架', 0, '2017-09-25 00:00:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for lp_notic
-- ----------------------------
DROP TABLE IF EXISTS `lp_notic`;
CREATE TABLE `lp_notic` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(80) NOT NULL,
  `content` text NOT NULL,
  `post_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  `c_id` int(255) NOT NULL,
  `role` int(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_notic
-- ----------------------------
BEGIN;
INSERT INTO `lp_notic` VALUES (1, '从数据库中读取的第一条测试数据', '从数据库中读取的第一条测试数据', '2017-09-24 00:00:00', NULL, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for lp_user
-- ----------------------------
DROP TABLE IF EXISTS `lp_user`;
CREATE TABLE `lp_user` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(16) NOT NULL DEFAULT '',
  `pass_word` varchar(32) NOT NULL DEFAULT '',
  `reg_time` datetime NOT NULL,
  `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(12) NOT NULL DEFAULT '',
  `email` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_user
-- ----------------------------
BEGIN;
INSERT INTO `lp_user` VALUES (1, '12', '12', '2017-09-22 08:28:00', '0000-00-00 00:00:00', '', NULL);
INSERT INTO `lp_user` VALUES (2, 'linkphp', '0a9baa05359cb93bdad561a14129d656', '2017-09-22 08:56:27', '0000-00-00 00:00:00', '', NULL);
INSERT INTO `lp_user` VALUES (3, 'links', '0a9baa05359cb93bdad561a14129d656', '2017-10-09 14:25:25', '0000-00-00 00:00:00', '', NULL);
INSERT INTO `lp_user` VALUES (4, 'links', '0a9baa05359cb93bdad561a14129d656', '2017-10-09 14:25:25', '0000-00-00 00:00:00', '', NULL);
INSERT INTO `lp_user` VALUES (5, 'artisan', 'cebb38a44eb0c92a727149a6a3158b5a', '2018-03-12 12:43:14', '0000-00-00 00:00:00', '', NULL);
INSERT INTO `lp_user` VALUES (6, 'admin123', 'cebb38a44eb0c92a727149a6a3158b5a', '2018-03-12 12:43:22', '0000-00-00 00:00:00', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for lp_wiki
-- ----------------------------
DROP TABLE IF EXISTS `lp_wiki`;
CREATE TABLE `lp_wiki` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `p_id` int(255) unsigned NOT NULL DEFAULT '0',
  `class_name` varchar(20) NOT NULL,
  `post_time` datetime DEFAULT NULL,
  `up_time` datetime DEFAULT NULL,
  `src` varchar(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lp_wiki
-- ----------------------------
BEGIN;
INSERT INTO `lp_wiki` VALUES (1, 0, 'linkphp开发手册', '2017-09-25 00:00:00', NULL, '');
INSERT INTO `lp_wiki` VALUES (2, 0, 'links入门', '2017-09-25 00:00:00', NULL, '');
INSERT INTO `lp_wiki` VALUES (3, 1, 'linkphp', '2017-09-25 00:00:00', NULL, 'linkphp');
INSERT INTO `lp_wiki` VALUES (4, 1, '前言', '2017-09-25 00:00:00', NULL, 'desc');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
